﻿CREATE TABLE [dbo].[email_Subscriber] (
    [Id]             INT            IDENTITY (1, 1) NOT NULL,
    [Email]          NVARCHAR (256) NOT NULL,
    [ActivationCode] VARCHAR (16)   DEFAULT ([dbo].[RandString]((16))) NOT NULL,
    [CreateDate]     DATETIME       DEFAULT (getutcdate()) NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [IX_email_Subscriber] UNIQUE NONCLUSTERED ([Email] ASC)
);



